#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time    : 2021/7/3 22:08
# @Author  : Crissu
# @Site    : 
# @File    : test2.py
# @Software: PyCharm
import xlrd

rootPath = "D:/yaoteam_dataset/dataset/linyehaichong/"
filePath = rootPath + "74speciesList.xls"

def readXLS():
    workbook = xlrd.open_workbook(filePath)  # 打开工作簿
    sheets = workbook.sheet_names()  # 获取工作簿中的所有表格
    worksheet = workbook.sheet_by_name(sheets[0])  # 获取工作簿中所有表格中的的第一个表格
    results = list()
    # 计算正确个数和分类总个数
    for i in range(0, worksheet.nrows):
        name = str(worksheet.cell_value(i, 0))
        results.append(name)
    print(results)
    return results

def makeFolders():
    folderSpecieRoot = rootPath + ""

if __name__ == '__main__':
    specieNameList = readXLS()
